In order to integrate the data sufficiently, promote the efficiency of analysis and inquiry by theme, area, and time, the Environmental Protection Administration (EPA) of Executive Yuan handles this Project to establish the Environmental Data Warehouse, so as to use it as the basis to promote the “Taiwan Environmental Data Center” (TENDC) in the future. The major work of this Project is to plan, design, develop, and establish the Environmental Data Warehouse system, purchase the relevant software and hardware, and regulate the operation standard and mechanism of data warehouse. The establishment process of data warehouse is to analyze the system requirement, interview the business unit, collect and analyze the data first, then discuss the category of theme, hold the consulting meeting of experts, plan the structure of warehouse, design the function of system, set up the software and hardware, complete the transformation of data files, extract, transfer, import the source data into data warehouse, and finish the development of inquire website finally. The Environmental Data Warehouse system has already finished 30 databases from the business units of Environmental Protection Administration. The data warehouse is divided into 8 themes, including the air quality, water, waste and resource recovery, toxic substances and environmental pesticides, soil, noise and radiation, and environmental management and others. The source data include the important data from the environmental monitoring, environmental statistics, environmental protection fund, control and monitoring premises, investigation and disciplinary, and the Environmental Management System (EMS). After the above-mentioned data are inputted into the data warehouse, the specific data structure of data warehouse is followed to store the physical data by the integration of theme orientation, fact table and dimension table (time, space, test item etc.), in order to reach the theme orientation, integration, analysis and multiple dimensional report inquiry function. About 27,650,000 data has already been gathered into the data warehouse in 2008. In order to assure the update of data in the data warehouse at any time, this Project stipulates the data update mechanism for data exchange, data loading, data transformation and import scheduling etc. Meantime, it provides the theme-type data display function, integrates the water quality monitoring data of the EPA and the river water amount data of the Water Resources Agency, controls and monitors the integrated data of pollution, and combines the comprehensive data of Google map and relevant authorities. This Project also employs the On-Line Analytical Processing (OLAP) to finish a single-station type, inter-business and inter-authority system with multiple dimensional data inquiry function by the condition of area, time, and theme etc., in order to reach the efficacy of environmental data integration and application fully. In the future, it can adopt the specific storage structure of data warehouse again to combine the Geographical Information System (GIS) more easily, in order to develop more applications on OLAP analysis and data mining.

environmental data warehouse system